<?php
/**
 * Prado Portal.
 *
 * @author Steen Rabol <steen.rabol@gmail.com>
 * @link http://www.pradoportal.dk/
 * @copyright Copyright &copy; 2006,2007,2008 Steen Rabol
 * @license http://www.pradoportal.dk
 * @version $Id: MySQL.php 289 2008-11-14 05:34:40Z steen.rabol@gmail.com $
 * @package Pradoportal.Portlets.PollPortlet.Install.MySQL
 *
 */
$drop_table[] = "DROP TABLE IF EXISTS `tblpolls`";
$create_table[] = "CREATE TABLE .`tblpolls` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `question` tinytext NOT NULL,
  `expire` int(10) unsigned NOT NULL default '0',
  `createdby` int(10) unsigned NOT NULL default '0',
  `barcolor` varchar(7) NOT NULL default '',
  `contentid` int(10) unsigned NOT NULL default '0',
  `active` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
)";

$drop_table[] = "DROP TABLE IF EXISTS `tblpollchoices`";
$create_table[] = "CREATE TABLE `tblpollchoices` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pollid` int(10) unsigned NOT NULL default '0',
  `answer` tinytext NOT NULL,
  `votes` int(10) unsigned NOT NULL default '0',
  `displayorder` decimal(7,3) NOT NULL default '0.000',
  PRIMARY KEY  (`id`)
)";

?>